﻿CREATE TABLE [dbo].[Cart] (
    [cartGUID]           UNIQUEIDENTIFIER NOT NULL,
    [patientID]          BIGINT           NOT NULL,
    [locationID]         INT              NOT NULL,
    [userID]             INT              NOT NULL,
    [taxFree]            BIT              NOT NULL,
    [cartDiscountPerc]   DECIMAL (4, 2)   NULL,
    [cartDiscountDollar] DECIMAL (5, 2)   NULL,
    [cartCreateDate]     DATETIME         NOT NULL,
    [cartCheckoutDate]   DATETIME         NULL,
    [cartSubTotal]       DECIMAL (7, 2)   NOT NULL,
    [cartTotal]          DECIMAL (7, 2)   NOT NULL,
    [transactionID]      NVARCHAR (50)    NULL,
    [cashPayment]        DECIMAL (5, 2)   NULL,
    [ccPayment]          DECIMAL (5, 2)   NULL,
    [ccLastFour]         NVARCHAR (4)     NULL,
    [giftCardPayment]    DECIMAL (5, 2)   NULL,
    [giftCardID]         NVARCHAR (50)    NULL,
    [promoCode]          NVARCHAR (50)    NULL
);









